Parameters Provided:
name.synonym = 1,3-Benzenedicarboxamide, N,N'-bis(2,3-dihydroxypropyl)-5-((hydroxyacetyl)(2-hydroxyethyl)amino)-2,4,6-triiodo-; BRN 7155654; Ioversol; Ioversol [USAN:INN:BAN]; Ioversolum [Latin]; LS-29726; MP-328; N,N'-Bis(2,3-dihydroxypropyl)-5-(N-(2-hydroxyethyl)glyco
filter.purchasability = all
page.num = 1
Structural Results Found: (before additional filtering)
SQL Query Was
SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '1,3-Benzenedicarboxamide, N,N\'-bis(2,3-dihydroxypropyl)-5-((hydroxyacetyl)(2-hydroxyethyl)amino)-2,4,6-triiodo-; BRN 7155654; Ioversol; Ioversol [USAN:INN:BAN]; Ioversolum [Latin]; LS-29726; MP-328; N,N\'-Bis(2,3-dihydroxypropyl)-5-(N-(2-hydroxyethyl)glyco' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id WHERE c.free = 1 ) LIMIT 50
Permalink
//zinc12.docking.org/results/combination?name.synonym=1%2C3-Benzenedicarboxamide%2C+N%2CN%27-bis%282%2C3-dihydroxypropyl%29-5-%28%28hydroxyacetyl%29%282-hydroxyethyl%29amino%29-2%2C4%2C6-triiodo-%3B+BRN+7155654%3B+Ioversol%3B+Ioversol+%5BUSAN%3AINN%3ABAN%5D%3B+Ioversolum+%5BLatin%5D%3B+LS-29726%3B+MP-328%3B+N%2CN%27-Bis%282%2C3-dihydroxypropyl%29-5-%28N-%282-hydroxyethyl%29glyco&filter.purchasability=all
Embed Link to Results
